WorkplaceManagement project databases hold all the information necessary for floors, desks and other assets, staff, reports, security groups, etc. that make up the project.
Note - Only make changes to WorkplaceManagement project databases if you are familiar with working in web application databases already. Modifications to the database are not technically supported.
WorkplaceManagement uses SQL Server Compact 4.0 databases. These file-based databases can be accessed by a number of different programs but we recommend using Microsoft Visual Studio.
SqlCe40Toolbox | http://workplacemanagement.isimsoftware.com/download/SqlCe40Toolbox.exe
Install SQL Server Compact Edition Runtime | http://workplacemanagement.isimsoftware.com/download/SSCERuntime_x64-ENU.exe
You can also use CompactView (requires a .NET framework version 4.0 or higher).
1. Open the project's file directory to find the project database (project.sdf).
Example File Path: C:\Program Files\WorkplaceManagement 4\Project-Name\data\project.sdf
2. Make a copy of the project file. This is now a back up in case changes need to be reverted.
3. Open SqlCe40.
4. Right click the 'No SQL Server Compact...' message at the top.
5. From the add dialog, click 'Browse..', navigate to and select the target database file.
6. Close the add dialog.
7. Open the project.sdf dropdown to view tables and information in the project.
This site was built with Mobirise